[dbo].[sp_asi_DeleteForum]

SQLServer > iMIS1521GA > Stored Procedures > dbo.sp_asi_DeleteForum

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@forum_seq	int	4

Permissions

Type	Action	Owning Principal
Grant	Execute	IMIS

SQL Script

CREATE PROCEDURE sp_asi_DeleteForum
@forum_seq int
as
delete from Cmty_Read_Tracking where  FORUM_SEQ = @forum_seq
delete from Cmty_Discussion_Posts where  FORUM_SEQ = @forum_seq
delete from Cmty_Discussion_Forums where FORUM_SEQ = @forum_seq
return

GO
GRANT EXECUTE ON  [dbo].[sp_asi_DeleteForum] TO [IMIS]
GO

Uses

[dbo].[Cmty_Discussion_Forums]
[dbo].[Cmty_Discussion_Posts]
[dbo].[Cmty_Read_Tracking]
dbo